﻿CREATE TABLE [v1].[UnitStratusMapping] (
    [UnitId]          INT      DEFAULT ((-1)) NOT NULL,
    [CostCentreId]    INT      DEFAULT ((-1)) NOT NULL,
    [UnitStartDate]   DATETIME DEFAULT ('19000101') NOT NULL,
    [UnitEndDate]     DATETIME DEFAULT ('99991231') NOT NULL,
    [UnitStartDateId] INT      DEFAULT ((19000101)) NOT NULL,
    [UnitEndDateId]   INT      DEFAULT ((99991231)) NOT NULL,
    [UnitRankId]      INT      DEFAULT ((-1)) NOT NULL,
    PRIMARY KEY CLUSTERED ([UnitId] ASC, [UnitStartDateId] ASC, [UnitEndDateId] ASC) WITH (FILLFACTOR = 90, ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

